﻿///***************************************************************
/// 시  스  템 : Updms.Ref.Dac
/// 단위시스템 : REF
/// 계      층 : Data Access Layer
/// 프로그램명 : Ref_Dac_UPDMS_REF_REPORT_Ref2010r
/// 파  일  명 : Ref_Dac_UPDMS_REF_REPORT_Ref2010r.cs
/// 설      명 : 기행기 캘린더
///***************************************************************
/// 수정ID 일자       이름     내용
///---------------------------------------------------------------
/// CH001  2013-04-30 송시명   최초 작성
///***************************************************************
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Runtime.InteropServices;

using SMFramework.Data;

namespace Updms.Ref.Dac
{
	[ComVisible(true)]
	[Transaction(TransactionOption.Supported)]
	[JustInTimeActivation(true)]
	public class Ref_Dac_UPDMS_REF_REPORT_Ref2010r : Base.AppFramework.DacBase
	{
		public Ref_Dac_UPDMS_REF_REPORT_Ref2010r()
		{
		}

		#region NT [GetMonthlyTour]
		/// <summary>
		/// 기행기 월별조회
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetMonthlyTour(DataPack lo_dp)
		{
			string ls_sql = "usp_UPDMS_REF_REPORT_Ref2010r_Get_Monthly_Tour";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			DataSet ds = new DataSet();
			return _agent.Fill(ls_sql, "UPDMS_REF_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion		

		#region NT [GetYearlyTour]
		/// <summary>
		/// 기행기 연도별조회
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetYearlyTour(DataPack lo_dp)
		{
			string ls_sql = "usp_UPDMS_REF_REPORT_Ref2010r_Get_Yearly_Tour";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			DataSet ds = new DataSet();
			return _agent.Fill(ls_sql, "UPDMS_REF_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion		

		#region NT [GetTourInfoBySeq]
		/// <summary>
		/// 기행기 상세조회
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetTourInfoBySeq(DataPack lo_dp)
		{
			string ls_sql = "usp_UPDMS_REF_REPORT_Ref2010r_Get_Tour_Info_By_Seq";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			DataSet ds = new DataSet();
			return _agent.Fill(ls_sql, "UPDMS_REF_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion

	}
}
